package com.example.czxyschool.mapper;

import com.yc.czxy.Mapper.BaseMapper;
import com.yc.czxy.bean.Topic;
import org.apache.ibatis.annotations.Select;
import java.util.List;

public interface TopicMapper extends BaseMapper {

    @Select("SELECT * from topic where sid = " +
            "(SELECT sid FROM school where location=#{location})")
    List<Topic> selectByLocation(String location);

    @Select("select * from topic")
    List<Topic> select();
}
